Department of Mathematicslab
DATABASE MANAGEMENT SYSTEMS LAB
DSE 3144
Syllabus
- 01MS Access
- 02Introduction to SQL
- 03Intermediate SQL
- 04Integrity Constraints in SQL
- 05Additional Exercises on SQL
- 06PL/SQL Basics
- 07Exception Handling and Cursors
- 08Additional Cursors constructs and Transactions
- 09Procedures
- 10Functions and Packages
- 11Triggers
- 12Mini Project
References
- Silberschatz, Korth, Sudarshan, Database System Concepts, (6e), McGraw-Hill, 2011
- Ivan Bayross, SQL, PL/SQL, (2e/3e), BPB Publications, 2009
- G. Reese, Database Programming with JDBS and Java, (2e), O'Reilly, 2000
Credits Structure
0Lecture
0Tutorial
3Practical
1Total